package com.atguigu.gulimall.product.service.impl;

import com.atguigu.gulimall.product.entity.AttrEntity;
import com.atguigu.gulimall.product.service.AttrService;
import com.atguigu.gulimall.product.service.CategoryBrandRelationService;
import com.atguigu.gulimall.product.vo.AttrGroupWithAttrsVo;
import com.atguigu.gulimall.product.vo.SkuItemVo;
import com.atguigu.gulimall.product.vo.SpuItemAttrGroupVo;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.atguigu.common.utils.PageUtils;
import com.atguigu.common.utils.Query;

import com.atguigu.gulimall.product.dao.AttrGroupDao;
import com.atguigu.gulimall.product.entity.AttrGroupEntity;
import com.atguigu.gulimall.product.service.AttrGroupService;


@Service("attrGroupService")
public class AttrGroupServiceImpl extends ServiceImpl<AttrGroupDao, AttrGroupEntity> implements AttrGroupService {

    @Autowired
    private CategoryBrandRelationService categoryBrandRelationService;

    @Autowired
    private AttrService attrService;

    @Override
    public PageUtils queryPage(Map<String, Object> params) {
        IPage<AttrGroupEntity> page = this.page(
                new Query<AttrGroupEntity>().getPage(params),
                new QueryWrapper<AttrGroupEntity>()
        );

        return new PageUtils(page);
    }

    @Override
    public PageUtils queryPage(Map<String, Object> params, Long categoryId) {
        String key = (String)params.get("key");

        if (0 == categoryId) {
            IPage<AttrGroupEntity> page = this.page(
                    new Query<AttrGroupEntity>().getPage(params),
                    new QueryWrapper<AttrGroupEntity>().lambda()
                            .and(StringUtils.isNotBlank(key),(wrapper) -> {
                                wrapper.eq(StringUtils.isNotBlank(key), AttrGroupEntity::getAttrGroupId, key)
                                        .or()
                                        .like(StringUtils.isNotBlank(key), AttrGroupEntity::getAttrGroupName, key);
                            })
            );
            return new PageUtils(page);
        }
        // select * from pms_attr_group where category_Id = ? and (attr_group_id=key or attr_group_name like '%key%')
        IPage<AttrGroupEntity> page = lambdaQuery().eq(AttrGroupEntity::getCatelogId, categoryId)
                .and(StringUtils.isNotBlank(key),(wrapper) -> {
                    wrapper.eq(StringUtils.isNotBlank(key), AttrGroupEntity::getAttrGroupId, key)
                            .or()
                            .like(StringUtils.isNotBlank(key), AttrGroupEntity::getAttrGroupName, key);
                }).page(new Query<AttrGroupEntity>().getPage(params));
        return new PageUtils(page);
    }

    /**
     * 根据分类id查出所有的分组以及这些组里面的属性
     * @param catelogId
     * @return
     */
    @Override
    public List<AttrGroupWithAttrsVo> getAttrGroupWithAttrsByCatelogId(Long catelogId) {
        //com.atguigu.gulimall.product.vo
        //1、查询分组信息
        List<AttrGroupEntity> attrGroupEntities = this.list(new QueryWrapper<AttrGroupEntity>().eq("catelog_id", catelogId));

        //2、查询所有属性
        List<AttrGroupWithAttrsVo> collect = attrGroupEntities.stream().map(group -> {
            AttrGroupWithAttrsVo attrsVo = new AttrGroupWithAttrsVo();
            BeanUtils.copyProperties(group,attrsVo);
            List<AttrEntity> attrs = attrService.getRelationAttr(attrsVo.getAttrGroupId());
            attrsVo.setAttrs(null == attrs ? new ArrayList<>():attrs);
            return attrsVo;
        }).collect(Collectors.toList());

        return collect;


    }

    @Override
    public List<SpuItemAttrGroupVo> getAttrGroupWithAttrsBySpuId(Long spuId, Long catalogId) {
        // 1、查出当前spu对应的所有属性的分组信息以及当前分组下所有属性对应的值
        // 1.1当前spu有多少对应的属性分组 groupName\attrName\attrValue
        /**
         * select ag.attr_group_id,ag.attr_group_name,aar.attr_id,attr.attr_Name
         * from pms_attr_group ag  left join pms_attr_attrgroup_relation aar on ag.attr_group_id = aar.attr_group_id
         * left join pms_attr attr on attr.attr_id = aar.attr_id
         * left join pms_product_attr_value pav on pav.attr_id = attr.attr_id
         * where ag.catelog_id = 225 and pav.spu_id = 12
         */
        List<SpuItemAttrGroupVo> vos = baseMapper.getAttrGroupWithAttrsBySpuId(spuId,catalogId);
        return vos;
    }


}